SELECT Id FROM new_searchtable
where
(town = 'Cornish' and state='NH'
or town = 'Eastman' and state='NH'
or town = 'Enfield' and state='NH'
or town = 'Hanover' and state='NH'
or town = 'Lebanon' and state='NH'
or town = 'Lyme' and state='NH'
or town = 'Plainfield' and state='NH'
)
and (type = 'R' or type ='O')
AND list_price BETWEEN '0' AND '30000000'
ORDER BY list_price Desc
Upper Valley Area NH Homes page 85
Granite Northland Associates
Serving Mascoma Lake Area
Call 603-523-7200
Description:Rarely available in one of Hanover’s most coveted in-town locations, this charming Gambrel Colonial offers the perfect blend of classic 1920s character, thoughtful updates, and unbeatable convenience. Tucked on a quiet street of only four homes on the edge of downtown Hanover, 1 Ripley Road is just moments from Main Street, Dartmouth College, local shops, restaurants, cafés, and all that Hanover has to offer within walking distance. Filled with wonderful natural light due to its excellent southern exposure, the home features three bedrooms, one and a half baths, hardwood flooring throughout, and a warm, inviting layout. The cozy living room includes a wood fireplace, while the dining room off the kitchen showcases a classic 1920s built-in adding timeless charm. The sunroom/family room offers a bright and comfortable additional living space, while the walk-out basement provides laundry, generous storage, a workout area, and office space, adding valuable flexibility to the home. Recent improvements include refinished first-floor flooring in 2020, all-new sunroom windows and fully refurbished first-floor windows with a second pane of glass and new seals in 2021. In 2022, the kitchen and first-floor bathroom were beautifully redone, and all appliances were replaced, offering the ease of modern updates while preserving the home’s original character. A truly special Hanover offering, this property combines charm with modern updates, light, privacy, and a prime walk-to-town location in a way that is increasingly hard to find.
Description:Just a short stroll from the Lyme Common sits a charming one-of-a-kind gem! Once a blacksmith shop, now a truly unique thoughtfully reimagined home with wonderful gathering spaces enriched by hardwood and wide pine floors, quality built-ins and even a fabulous patio where you can enjoy a cup of coffee while taking in beautiful gardens and an expansive lawn. The property consists of a four-bedroom main house in addition to a 2019 built two-bedroom cottage presently being used as an office. Wander up Market Street to find restaurants, shops and award-winning Lyme Elementary School or get there via The Big Rock Nature Preserve trail directly across from your front door. Lyme offers many recreational opportunities from the Dartmouth Skiway, cross country skiing at the Greens to Post Pond for swimming and of course extensive hiking trails and a short drive to Dartmouth College, Hanover and DHMC. Open Houses Sat May 23 & Sun May 24 from 12-2pm.The listing agent holds an ownership interest in the property.
Description:Don't miss out on this incredible opportunity to own a beautiful commercial/residential zoned property in a highly visible area of Hanover, NH. Ideallysituated right on Route 10 (Lyme Road), just minutes from downtown Hanover and within walking distance of the elementary and middle schools, this property features agorgeous post and beam building connected by a breezeway to an additional building, with plenty of parking. Constructed by the renowned Timberpeg builders, the mainbuilding offers 3 levels of finished space, including a vaulted ceiling entryway suffused with natural light, a suite of offices, most of which feature en-suite bathrooms, aspacious shared kitchen, and a media room. The smaller building is a versatile 2-story space, originally built as a squash court, but ripe for use as a yoga studio, retailspace, or apartments. The newer zoning status allows for 49% of the buildings to be converted into residential living space, opening up endless possibilities for a buyer.This property has been beautifully maintained and updated over time, including a high-efficiency pellet boiler to help reduce expenses and carbon footprint. Take advantage of this unique Hanover offering and bring your ideas!
Description:DRUM ROLL PLEASE!! A pleasure and a privilege to introduce this GEM - AIA Vermont Design Award 2004 winner. The design and cleverly sited Contemporary waterfront home embodies flair, creative use of space, ingenuity, workmanship, charm and a WOW factor from the minute you enter the door. Light filled, open floor plan on the main level with great large windows, living room with two-way fireplace, with black marble lintel, extends the indoor to outdoor living space on an amazing screened porch complete with views to the Lake and the Knox River at Shaker Boulevard!! AND THEN The Cottage House!! This is another GEM, totally renovated with a well thought out floor plan consisting of one bedroom, kitchen, living/dining area, 1.5 bathrooms, full basement and an amazing wraparound porch with VIEWS, up the Lake and all around!! To describe the setting: Private, level, beach area, docks and an estuary to watch the birds and ecosystem of life survive. This is a must see!!
Description:Located off of picturesque River Road in the lovely cul-de-sac neighborhood of Purling Brooks, this spacious, light-filled five bedroom, five bathroom home offers an exceptional blend of comfort, flexibility, and natural beauty. A welcoming front porch overlooking mature gardens creates a perfect spot to relax and enjoy the peaceful surroundings and expansive yard. The neighborhood abuts conservation land and scenic walking trails. A standout feature is the private accessory dwelling unit (ADU), with its own kitchen, living room, bedroom, bathroom and laundry- a versatile space for guests, extended family, a nanny, or potential rental income. The main home’s open-concept kitchen flows seamlessly into a spacious living room highlighted by soaring cathedral ceilings and a cozy propane fireplace. From the living room, step into the inviting three-season screened porch—an ideal retreat for relaxing, entertaining, or enjoying the private surrounding yard. The main level also includes a formal dining room, comfortable living room and a bedroom, which could easily serve as a private office or bonus room. Upstairs, the expansive primary bedroom ensuite features three walk-in closets, complemented by two additional bedrooms, a bathroom, a dedicated office or activity area, and a convenient second-floor laundry room. The large finished basement provides abundant space for recreation, entertainment, a potential sixth bedroom, and storage. Set in a desirable neighborhood with direct access to nature, this exceptional home offers space and versatility. A truly wonderful place to call home. Seller is a licensed real estate agent.